DROP TABLE IF EXISTS `companies`;
CREATE TABLE `companies` (
  `id` bigint(99) NOT NULL,
  `name` varchar(255) default NULL,
  `website` varchar(255) default NULL,
  `first_name` varchar(255) default NULL,
  `last_name` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `zip` varchar(255) default NULL,
  `office_phone_number` varchar(255) default NULL,
  `toll_free_number` varchar(255) default NULL,
  `fax_number` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `airport_one` varchar(255) default NULL,
  `airport_two` varchar(255) default NULL,
  `airport_three` varchar(255) default NULL,
  `airport_four` varchar(255) default NULL,
  `airport_five` varchar(255) default NULL,
  `airport_six` varchar(255) default NULL,
  `airport_seven` varchar(255) default NULL,
  `airport_eight` varchar(255) default NULL,  
  `target_area_one` varchar(255) default NULL,
  `target_area_two` varchar(255) default NULL,
  `target_area_three` varchar(255) default NULL,  
  `target_area_four` varchar(255) default NULL,  
  `dt_changed` timestamp(14) NOT NULL,  
	`airtrans` varchar(1) default NULL,
	`weddings` varchar(1) default NULL,
	`prom` varchar(1) default NULL,  
	`bachelor_party` varchar(1) default NULL,
	`anniversaries` varchar(1) default NULL,
	`point2point` varchar(1) default NULL,
	`birthday_party` varchar(1) default NULL,
	`concert` varchar(1) default NULL,
	`graduation` varchar(1) default NULL,
	`sport_event` varchar(1) default NULL,
	`holiday_lights_tour` varchar(1) default NULL,
	`night_on_the_town` varchar(1) default NULL,
	`other` varchar(1) default NULL, 
	`sedan` varchar(1) default NULL,
	`limo` varchar(1) default NULL,
	`strech_limo` varchar(1) default NULL,
	`van` varchar(1) default NULL,
	`paratrans_van` varchar(1) default NULL,
	`handicap_access` varchar(1) default NULL,
	`suv` varchar(1) default NULL,
	`minibus` varchar(1) default NULL,
	`antique_vehicle` varchar(1) default NULL,
	`rolls_royce` varchar(1) default NULL,
	`partybus_620` varchar(1) default NULL,
  `partybus_20plus` varchar(1) default NULL,   
  PRIMARY KEY  (`id`)
) TYPE=MyISAM; 

  FOREIGN KEY (`service_id`) REFERENCES services(id) ON DELETE CASCADE,
  FOREIGN KEY (`fleet_id`) REFERENCES fleet(id) ON DELETE CASCADE